WASHINGTON—Sen. Al Franken said Thursday that he will resign in the coming weeks, in a speech on the Senate floor that put him face to face with dozens of Democratic colleagues who called for him to step down over mounting allegations of sexual misconduct.